﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="dsProductos" targetNamespace="http://tempuri.org/dsProductos.xsd" xmlns:mstns="http://tempuri.org/dsProductos.xsd" xmlns="http://tempuri.org/dsProductos.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="3" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="ConnectionString4" IsAppSettingsProperty="true" Modifier="Assembly" Name="ConnectionString4 (MySettings)" ParameterPrefix=":" PropertyReference="ApplicationSettings.lbGlobalcom.My.MySettings.GlobalReference.Default.ConnectionString4" Provider="Oracle.DataAccess.Client" />
          <Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="ConnectionString1" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="ConnectionString1 (MySettings)" ParameterPrefix=":" PropertyReference="ApplicationSettings.lbGlobalcom.My.MySettings.GlobalReference.Default.ConnectionString1" Provider="Oracle.DataAccess.Client" />
          <Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="ConnectionString6" IsAppSettingsProperty="true" Modifier="Assembly" Name="ConnectionString6 (MySettings)" ParameterPrefix=":" PropertyReference="ApplicationSettings.lbGlobalcom.My.MySettings.GlobalReference.Default.ConnectionString6" Provider="Oracle.DataAccess.Client" />
          <Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="ConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="ConnectionString (MySettings)" ParameterPrefix=":" PropertyReference="ApplicationSettings.lbGlobalcom.My.MySettings.GlobalReference.Default.ConnectionString" Provider="System.Data.OracleClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PRO_PLANESTableAdapter" GeneratorDataComponentClassName="PRO_PLANESTableAdapter" Name="PRO_PLANES" UserDataComponentName="PRO_PLANESTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.PRO_PLANES" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM "PRO_PLANES" WHERE (("IDPLAN" = :Original_IDPLAN) AND ((:IsNull_DESCRIPCION = 1 AND "DESCRIPCION" IS NULL) OR ("DESCRIPCION" = :Original_DESCRIPCION)) AND ((:IsNull_COMISION = 1 AND "COMISION" IS NULL) OR ("COMISION" = :Original_COMISION)) AND ((:IsNull_VALORBASE = 1 AND "VALORBASE" IS NULL) OR ("VALORBASE" = :Original_VALORBASE)) AND ((:IsNull_VALORIVA = 1 AND "VALORIVA" IS NULL) OR ("VALORIVA" = :Original_VALORIVA)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDPLAN" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDPLAN" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_DESCRIPCION" Precision="0" ProviderType="Int32" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_DESCRIPCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_COMISION" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="COMISION" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_COMISION" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="COMISION" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_VALORBASE" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="VALORBASE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_VALORBASE" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="VALORBASE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_VALORIVA" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="VALORIVA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_VALORIVA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="VALORIVA" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO "PRO_PLANES" ("IDPLAN", "DESCRIPCION", "COMISION", "VALORBASE", "VALORIVA") VALUES (:IDPLAN, :DESCRIPCION, :COMISION, :VALORBASE, :VALORIVA)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDPLAN" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDPLAN" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="DESCRIPCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="COMISION" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="COMISION" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="VALORBASE" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="VALORBASE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="VALORIVA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="VALORIVA" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     IDPLAN, DESCRIPCION, COMISION, VALORBASE, VALORIVA
FROM         PRO_PLANES
ORDER BY IDPLAN</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE "PRO_PLANES" SET "IDPLAN" = :IDPLAN, "DESCRIPCION" = :DESCRIPCION, "COMISION" = :COMISION, "VALORBASE" = :VALORBASE, "VALORIVA" = :VALORIVA WHERE (("IDPLAN" = :Original_IDPLAN) AND ((:IsNull_DESCRIPCION = 1 AND "DESCRIPCION" IS NULL) OR ("DESCRIPCION" = :Original_DESCRIPCION)) AND ((:IsNull_COMISION = 1 AND "COMISION" IS NULL) OR ("COMISION" = :Original_COMISION)) AND ((:IsNull_VALORBASE = 1 AND "VALORBASE" IS NULL) OR ("VALORBASE" = :Original_VALORBASE)) AND ((:IsNull_VALORIVA = 1 AND "VALORIVA" IS NULL) OR ("VALORIVA" = :Original_VALORIVA)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDPLAN" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDPLAN" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="DESCRIPCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="COMISION" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="COMISION" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="VALORBASE" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="VALORBASE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="VALORIVA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="VALORIVA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDPLAN" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDPLAN" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_DESCRIPCION" Precision="0" ProviderType="Int32" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_DESCRIPCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_COMISION" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="COMISION" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_COMISION" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="COMISION" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_VALORBASE" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="VALORBASE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_VALORBASE" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="VALORBASE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_VALORIVA" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="VALORIVA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_VALORIVA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="VALORIVA" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDPLAN" DataSetColumn="IDPLAN" />
              <Mapping SourceColumn="DESCRIPCION" DataSetColumn="DESCRIPCION" />
              <Mapping SourceColumn="COMISION" DataSetColumn="COMISION" />
              <Mapping SourceColumn="VALORBASE" DataSetColumn="VALORBASE" />
              <Mapping SourceColumn="VALORIVA" DataSetColumn="VALORIVA" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.PRO_PLANES" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByIdPlan" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByIdPlan" GeneratorSourceName="FillByIdPlan" GetMethodModifier="Public" GetMethodName="GetDataByIdPlan" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByIdPlan" UserSourceName="FillByIdPlan">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT COMISION, DESCRIPCION, IDPLAN, VALORBASE, VALORIVA FROM PRO_PLANES WHERE (IDPLAN = :PIDPLAN)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="PIDPLAN" ColumnName="IDPLAN" DataSourceName="SAMUEL.PRO_PLANES" DataTypeServer="VARCHAR2(5)" DbType="String" Direction="Input" ParameterName=":PIDPLAN" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDPLAN" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PRO_PRODUCTOTableAdapter" GeneratorDataComponentClassName="PRO_PRODUCTOTableAdapter" Name="PRO_PRODUCTO" UserDataComponentName="PRO_PRODUCTOTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.PRO_PRODUCTO" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM "PRO_PRODUCTO" WHERE (("IDPRODUCTO" = :Original_IDPRODUCTO) AND ((:IsNull_DESCRICION = 1 AND "DESCRICION" IS NULL) OR ("DESCRICION" = :Original_DESCRICION)) AND ((:IsNull_APLICARANGODTO = 1 AND "APLICARANGODTO" IS NULL) OR ("APLICARANGODTO" = :Original_APLICARANGODTO)) AND ((:IsNull_CONTENIDO = 1 AND "CONTENIDO" IS NULL) OR ("CONTENIDO" = :Original_CONTENIDO)) AND ((:IsNull_COSTO = 1 AND "COSTO" IS NULL) OR ("COSTO" = :Original_COSTO)) AND ((:IsNull_EAN = 1 AND "EAN" IS NULL) OR ("EAN" = :Original_EAN)) AND ((:IsNull_ESTADO = 1 AND "ESTADO" IS NULL) OR ("ESTADO" = :Original_ESTADO)) AND ((:IsNull_IDTIPOIVA = 1 AND "IDTIPOIVA" IS NULL) OR ("IDTIPOIVA" = :Original_IDTIPOIVA)) AND ((:IsNull_IDTIPOPRODUCTO = 1 AND "IDTIPOPRODUCTO" IS NULL) OR ("IDTIPOPRODUCTO" = :Original_IDTIPOPRODUCTO)) AND ((:IsNull_REFERENCIA = 1 AND "REFERENCIA" IS NULL) OR ("REFERENCIA" = :Original_REFERENCIA)) AND ((:IsNull_UNIDAD = 1 AND "UNIDAD" IS NULL) OR ("UNIDAD" = :Original_UNIDAD)) AND ((:IsNull_IDMARCA = 1 AND "IDMARCA" IS NULL) OR ("IDMARCA" = :Original_IDMARCA)) AND ((:IsNull_IDCLASE = 1 AND "IDCLASE" IS NULL) OR ("IDCLASE" = :Original_IDCLASE)) AND ((:IsNull_ESPADRE = 1 AND "ESPADRE" IS NULL) OR ("ESPADRE" = :Original_ESPADRE)) AND ((:IsNull_TIPOSUBPROD = 1 AND "TIPOSUBPROD" IS NULL) OR ("TIPOSUBPROD" = :Original_TIPOSUBPROD)) AND ((:IsNull_CANTIDADSUBPROD = 1 AND "CANTIDADSUBPROD" IS NULL) OR ("CANTIDADSUBPROD" = :Original_CANTIDADSUBPROD)) AND ((:IsNull_ICCIDENCOMPRAS = 1 AND "ICCIDENCOMPRAS" IS NULL) OR ("ICCIDENCOMPRAS" = :Original_ICCIDENCOMPRAS)) AND ((:IsNull_IDPRODCONVIERTE = 1 AND "IDPRODCONVIERTE" IS NULL) OR ("IDPRODCONVIERTE" = :Original_IDPRODCONVIERTE)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDPRODUCTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="IDPRODUCTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_DESCRICION" Precision="0" ProviderType="Int32" Scale="0" Size="50" SourceColumn="DESCRICION" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_DESCRICION" Precision="0" ProviderType="Varchar2" Scale="0" Size="50" SourceColumn="DESCRICION" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_APLICARANGODTO" Precision="0" ProviderType="Int32" Scale="0" Size="1" SourceColumn="APLICARANGODTO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="Original_APLICARANGODTO" Precision="0" ProviderType="Char" Scale="0" Size="1" SourceColumn="APLICARANGODTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_CONTENIDO" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="CONTENIDO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_CONTENIDO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="CONTENIDO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_COSTO" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="COSTO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_COSTO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="COSTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_EAN" Precision="0" ProviderType="Int32" Scale="0" Size="20" SourceColumn="EAN" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_EAN" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="EAN" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ESTADO" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="ESTADO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_ESTADO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="ESTADO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDTIPOIVA" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDTIPOIVA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDTIPOIVA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDTIPOIVA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDTIPOPRODUCTO" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDTIPOPRODUCTO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDTIPOPRODUCTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDTIPOPRODUCTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_REFERENCIA" Precision="0" ProviderType="Int32" Scale="0" Size="15" SourceColumn="REFERENCIA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_REFERENCIA" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="REFERENCIA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_UNIDAD" Precision="0" ProviderType="Int32" Scale="0" Size="10" SourceColumn="UNIDAD" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_UNIDAD" Precision="0" ProviderType="Varchar2" Scale="0" Size="10" SourceColumn="UNIDAD" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDMARCA" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDMARCA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDMARCA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDMARCA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDCLASE" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDCLASE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDCLASE" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDCLASE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ESPADRE" Precision="0" ProviderType="Int32" Scale="0" Size="1" SourceColumn="ESPADRE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="Original_ESPADRE" Precision="0" ProviderType="Char" Scale="0" Size="1" SourceColumn="ESPADRE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_TIPOSUBPROD" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="TIPOSUBPROD" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_TIPOSUBPROD" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="TIPOSUBPROD" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_CANTIDADSUBPROD" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="CANTIDADSUBPROD" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_CANTIDADSUBPROD" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="CANTIDADSUBPROD" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ICCIDENCOMPRAS" Precision="0" ProviderType="Int32" Scale="0" Size="1" SourceColumn="ICCIDENCOMPRAS" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="Original_ICCIDENCOMPRAS" Precision="0" ProviderType="Char" Scale="0" Size="1" SourceColumn="ICCIDENCOMPRAS" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDPRODCONVIERTE" Precision="0" ProviderType="Int32" Scale="0" Size="20" SourceColumn="IDPRODCONVIERTE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDPRODCONVIERTE" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="IDPRODCONVIERTE" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO "PRO_PRODUCTO" ("IDPRODUCTO", "DESCRICION", "APLICARANGODTO", "CONTENIDO", "COSTO", "EAN", "ESTADO", "IDTIPOIVA", "IDTIPOPRODUCTO", "REFERENCIA", "UNIDAD", "IDMARCA", "IDCLASE", "ESPADRE", "TIPOSUBPROD", "CANTIDADSUBPROD", "ICCIDENCOMPRAS", "IDPRODCONVIERTE") VALUES (:IDPRODUCTO, :DESCRICION, :APLICARANGODTO, :CONTENIDO, :COSTO, :EAN, :ESTADO, :IDTIPOIVA, :IDTIPOPRODUCTO, :REFERENCIA, :UNIDAD, :IDMARCA, :IDCLASE, :ESPADRE, :TIPOSUBPROD, :CANTIDADSUBPROD, :ICCIDENCOMPRAS, :IDPRODCONVIERTE)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDPRODUCTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="IDPRODUCTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="DESCRICION" Precision="0" ProviderType="Varchar2" Scale="0" Size="50" SourceColumn="DESCRICION" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="APLICARANGODTO" Precision="0" ProviderType="Char" Scale="0" Size="1" SourceColumn="APLICARANGODTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="CONTENIDO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="CONTENIDO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="COSTO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="COSTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="EAN" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="EAN" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="ESTADO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="ESTADO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDTIPOIVA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDTIPOIVA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDTIPOPRODUCTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDTIPOPRODUCTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="REFERENCIA" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="REFERENCIA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="UNIDAD" Precision="0" ProviderType="Varchar2" Scale="0" Size="10" SourceColumn="UNIDAD" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDMARCA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDMARCA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDCLASE" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDCLASE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="ESPADRE" Precision="0" ProviderType="Char" Scale="0" Size="1" SourceColumn="ESPADRE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="TIPOSUBPROD" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="TIPOSUBPROD" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="CANTIDADSUBPROD" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="CANTIDADSUBPROD" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="ICCIDENCOMPRAS" Precision="0" ProviderType="Char" Scale="0" Size="1" SourceColumn="ICCIDENCOMPRAS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDPRODCONVIERTE" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="IDPRODCONVIERTE" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        IDPRODUCTO, DESCRICION, APLICARANGODTO, CONTENIDO, COSTO, EAN, ESTADO, IDTIPOIVA, IDTIPOPRODUCTO, REFERENCIA, UNIDAD, IDMARCA, IDCLASE, 
                         ESPADRE, TIPOSUBPROD, CANTIDADSUBPROD, ICCIDENCOMPRAS, IDPRODCONVIERTE
FROM            PRO_PRODUCTO</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE "PRO_PRODUCTO" SET "IDPRODUCTO" = :IDPRODUCTO, "DESCRICION" = :DESCRICION, "APLICARANGODTO" = :APLICARANGODTO, "CONTENIDO" = :CONTENIDO, "COSTO" = :COSTO, "EAN" = :EAN, "ESTADO" = :ESTADO, "IDTIPOIVA" = :IDTIPOIVA, "IDTIPOPRODUCTO" = :IDTIPOPRODUCTO, "REFERENCIA" = :REFERENCIA, "UNIDAD" = :UNIDAD, "IDMARCA" = :IDMARCA, "IDCLASE" = :IDCLASE, "ESPADRE" = :ESPADRE, "TIPOSUBPROD" = :TIPOSUBPROD, "CANTIDADSUBPROD" = :CANTIDADSUBPROD, "ICCIDENCOMPRAS" = :ICCIDENCOMPRAS, "IDPRODCONVIERTE" = :IDPRODCONVIERTE WHERE (("IDPRODUCTO" = :Original_IDPRODUCTO) AND ((:IsNull_DESCRICION = 1 AND "DESCRICION" IS NULL) OR ("DESCRICION" = :Original_DESCRICION)) AND ((:IsNull_APLICARANGODTO = 1 AND "APLICARANGODTO" IS NULL) OR ("APLICARANGODTO" = :Original_APLICARANGODTO)) AND ((:IsNull_CONTENIDO = 1 AND "CONTENIDO" IS NULL) OR ("CONTENIDO" = :Original_CONTENIDO)) AND ((:IsNull_COSTO = 1 AND "COSTO" IS NULL) OR ("COSTO" = :Original_COSTO)) AND ((:IsNull_EAN = 1 AND "EAN" IS NULL) OR ("EAN" = :Original_EAN)) AND ((:IsNull_ESTADO = 1 AND "ESTADO" IS NULL) OR ("ESTADO" = :Original_ESTADO)) AND ((:IsNull_IDTIPOIVA = 1 AND "IDTIPOIVA" IS NULL) OR ("IDTIPOIVA" = :Original_IDTIPOIVA)) AND ((:IsNull_IDTIPOPRODUCTO = 1 AND "IDTIPOPRODUCTO" IS NULL) OR ("IDTIPOPRODUCTO" = :Original_IDTIPOPRODUCTO)) AND ((:IsNull_REFERENCIA = 1 AND "REFERENCIA" IS NULL) OR ("REFERENCIA" = :Original_REFERENCIA)) AND ((:IsNull_UNIDAD = 1 AND "UNIDAD" IS NULL) OR ("UNIDAD" = :Original_UNIDAD)) AND ((:IsNull_IDMARCA = 1 AND "IDMARCA" IS NULL) OR ("IDMARCA" = :Original_IDMARCA)) AND ((:IsNull_IDCLASE = 1 AND "IDCLASE" IS NULL) OR ("IDCLASE" = :Original_IDCLASE)) AND ((:IsNull_ESPADRE = 1 AND "ESPADRE" IS NULL) OR ("ESPADRE" = :Original_ESPADRE)) AND ((:IsNull_TIPOSUBPROD = 1 AND "TIPOSUBPROD" IS NULL) OR ("TIPOSUBPROD" = :Original_TIPOSUBPROD)) AND ((:IsNull_CANTIDADSUBPROD = 1 AND "CANTIDADSUBPROD" IS NULL) OR ("CANTIDADSUBPROD" = :Original_CANTIDADSUBPROD)) AND ((:IsNull_ICCIDENCOMPRAS = 1 AND "ICCIDENCOMPRAS" IS NULL) OR ("ICCIDENCOMPRAS" = :Original_ICCIDENCOMPRAS)) AND ((:IsNull_IDPRODCONVIERTE = 1 AND "IDPRODCONVIERTE" IS NULL) OR ("IDPRODCONVIERTE" = :Original_IDPRODCONVIERTE)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDPRODUCTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="IDPRODUCTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="DESCRICION" Precision="0" ProviderType="Varchar2" Scale="0" Size="50" SourceColumn="DESCRICION" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="APLICARANGODTO" Precision="0" ProviderType="Char" Scale="0" Size="1" SourceColumn="APLICARANGODTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="CONTENIDO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="CONTENIDO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="COSTO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="COSTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="EAN" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="EAN" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="ESTADO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="ESTADO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDTIPOIVA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDTIPOIVA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDTIPOPRODUCTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDTIPOPRODUCTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="REFERENCIA" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="REFERENCIA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="UNIDAD" Precision="0" ProviderType="Varchar2" Scale="0" Size="10" SourceColumn="UNIDAD" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDMARCA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDMARCA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDCLASE" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDCLASE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="ESPADRE" Precision="0" ProviderType="Char" Scale="0" Size="1" SourceColumn="ESPADRE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="TIPOSUBPROD" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="TIPOSUBPROD" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="CANTIDADSUBPROD" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="CANTIDADSUBPROD" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="ICCIDENCOMPRAS" Precision="0" ProviderType="Char" Scale="0" Size="1" SourceColumn="ICCIDENCOMPRAS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDPRODCONVIERTE" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="IDPRODCONVIERTE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDPRODUCTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="IDPRODUCTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_DESCRICION" Precision="0" ProviderType="Int32" Scale="0" Size="50" SourceColumn="DESCRICION" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_DESCRICION" Precision="0" ProviderType="Varchar2" Scale="0" Size="50" SourceColumn="DESCRICION" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_APLICARANGODTO" Precision="0" ProviderType="Int32" Scale="0" Size="1" SourceColumn="APLICARANGODTO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="Original_APLICARANGODTO" Precision="0" ProviderType="Char" Scale="0" Size="1" SourceColumn="APLICARANGODTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_CONTENIDO" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="CONTENIDO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_CONTENIDO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="CONTENIDO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_COSTO" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="COSTO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_COSTO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="COSTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_EAN" Precision="0" ProviderType="Int32" Scale="0" Size="20" SourceColumn="EAN" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_EAN" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="EAN" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ESTADO" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="ESTADO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_ESTADO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="ESTADO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDTIPOIVA" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDTIPOIVA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDTIPOIVA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDTIPOIVA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDTIPOPRODUCTO" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDTIPOPRODUCTO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDTIPOPRODUCTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDTIPOPRODUCTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_REFERENCIA" Precision="0" ProviderType="Int32" Scale="0" Size="15" SourceColumn="REFERENCIA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_REFERENCIA" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="REFERENCIA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_UNIDAD" Precision="0" ProviderType="Int32" Scale="0" Size="10" SourceColumn="UNIDAD" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_UNIDAD" Precision="0" ProviderType="Varchar2" Scale="0" Size="10" SourceColumn="UNIDAD" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDMARCA" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDMARCA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDMARCA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDMARCA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDCLASE" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDCLASE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDCLASE" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDCLASE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ESPADRE" Precision="0" ProviderType="Int32" Scale="0" Size="1" SourceColumn="ESPADRE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="Original_ESPADRE" Precision="0" ProviderType="Char" Scale="0" Size="1" SourceColumn="ESPADRE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_TIPOSUBPROD" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="TIPOSUBPROD" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_TIPOSUBPROD" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="TIPOSUBPROD" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_CANTIDADSUBPROD" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="CANTIDADSUBPROD" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_CANTIDADSUBPROD" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="CANTIDADSUBPROD" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ICCIDENCOMPRAS" Precision="0" ProviderType="Int32" Scale="0" Size="1" SourceColumn="ICCIDENCOMPRAS" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="Original_ICCIDENCOMPRAS" Precision="0" ProviderType="Char" Scale="0" Size="1" SourceColumn="ICCIDENCOMPRAS" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDPRODCONVIERTE" Precision="0" ProviderType="Int32" Scale="0" Size="20" SourceColumn="IDPRODCONVIERTE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDPRODCONVIERTE" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="IDPRODCONVIERTE" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDPRODUCTO" DataSetColumn="IDPRODUCTO" />
              <Mapping SourceColumn="DESCRICION" DataSetColumn="DESCRICION" />
              <Mapping SourceColumn="APLICARANGODTO" DataSetColumn="APLICARANGODTO" />
              <Mapping SourceColumn="CONTENIDO" DataSetColumn="CONTENIDO" />
              <Mapping SourceColumn="COSTO" DataSetColumn="COSTO" />
              <Mapping SourceColumn="EAN" DataSetColumn="EAN" />
              <Mapping SourceColumn="ESTADO" DataSetColumn="ESTADO" />
              <Mapping SourceColumn="IDTIPOIVA" DataSetColumn="IDTIPOIVA" />
              <Mapping SourceColumn="IDTIPOPRODUCTO" DataSetColumn="IDTIPOPRODUCTO" />
              <Mapping SourceColumn="REFERENCIA" DataSetColumn="REFERENCIA" />
              <Mapping SourceColumn="UNIDAD" DataSetColumn="UNIDAD" />
              <Mapping SourceColumn="IDMARCA" DataSetColumn="IDMARCA" />
              <Mapping SourceColumn="IDCLASE" DataSetColumn="IDCLASE" />
              <Mapping SourceColumn="ESPADRE" DataSetColumn="ESPADRE" />
              <Mapping SourceColumn="TIPOSUBPROD" DataSetColumn="TIPOSUBPROD" />
              <Mapping SourceColumn="CANTIDADSUBPROD" DataSetColumn="CANTIDADSUBPROD" />
              <Mapping SourceColumn="ICCIDENCOMPRAS" DataSetColumn="ICCIDENCOMPRAS" />
              <Mapping SourceColumn="IDPRODCONVIERTE" DataSetColumn="IDPRODCONVIERTE" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.PRO_PRODUCTO" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByIdProducto" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByIdProducto" GeneratorSourceName="FillByIdProducto" GetMethodModifier="Public" GetMethodName="GetDataByIdProducto" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByIdProducto" UserSourceName="FillByIdProducto">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT APLICARANGODTO, CANTIDADSUBPROD, CONTENIDO, COSTO, DESCRICION, EAN, ESPADRE, ESTADO, ICCIDENCOMPRAS, IDCLASE, IDMARCA, IDPRODCONVIERTE, IDPRODUCTO, IDTIPOIVA, IDTIPOPRODUCTO, REFERENCIA, TIPOSUBPROD, UNIDAD FROM PRO_PRODUCTO WHERE (IDPRODUCTO = :IDPRODUCTO)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="IDPRODUCTO" ColumnName="IDPRODUCTO" DataSourceName="SAMUEL.PRO_PRODUCTO" DataTypeServer="VARCHAR2(20)" DbType="String" Direction="Input" ParameterName=":IDPRODUCTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="IDPRODUCTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.PRO_PRODUCTO" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByidTipoProducto" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByidTipoProducto" GeneratorSourceName="FillByidTipoProducto" GetMethodModifier="Public" GetMethodName="GetDataByidTipoProducto" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByidTipoProducto" UserSourceName="FillByidTipoProducto">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT APLICARANGODTO, CANTIDADSUBPROD, CONTENIDO, COSTO, DESCRICION, EAN, ESPADRE, ESTADO, ICCIDENCOMPRAS, IDCLASE, IDMARCA, IDPRODCONVIERTE, IDPRODUCTO, IDTIPOIVA, IDTIPOPRODUCTO, REFERENCIA, TIPOSUBPROD, UNIDAD FROM PRO_PRODUCTO WHERE (IDTIPOPRODUCTO = :IDTIPOPRODUCTO)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="IDTIPOPRODUCTO" ColumnName="IDTIPOPRODUCTO" DataSourceName="SAMUEL.PRO_PRODUCTO" DataTypeServer="VARCHAR2(5)" DbType="String" Direction="Input" ParameterName=":IDTIPOPRODUCTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDTIPOPRODUCTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBy" GeneratorSourceName="GetNombreProducto" Modifier="Public" Name="GetNombreProducto" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="GetNombreProducto">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT      DESCRICION || ' -CONTENIDO:' || CONTENIDO AS DESCRIPCION
FROM         PRO_PRODUCTO
WHERE IDPRODUCTO=:PIDPRODUCTO</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="PIDPRODUCTO" ColumnName="IDPRODUCTO" DataSourceName="" DataTypeServer="VARCHAR2(20)" DbType="String" Direction="Input" ParameterName=":PIDPRODUCTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="IDPRODUCTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PRO_TIPOPRODUCTOTableAdapter" GeneratorDataComponentClassName="PRO_TIPOPRODUCTOTableAdapter" Name="PRO_TIPOPRODUCTO" UserDataComponentName="PRO_TIPOPRODUCTOTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.PRO_TIPOPRODUCTO" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM "PRO_TIPOPRODUCTO" WHERE (("IDTIPOPRODUCTO" = :Original_IDTIPOPRODUCTO) AND ((:IsNull_DESCRIPCION = 1 AND "DESCRIPCION" IS NULL) OR ("DESCRIPCION" = :Original_DESCRIPCION)) AND ((:IsNull_PREFIJO = 1 AND "PREFIJO" IS NULL) OR ("PREFIJO" = :Original_PREFIJO)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDTIPOPRODUCTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="6" SourceColumn="IDTIPOPRODUCTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_DESCRIPCION" Precision="0" ProviderType="Int32" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_DESCRIPCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_PREFIJO" Precision="0" ProviderType="Int32" Scale="0" Size="3" SourceColumn="PREFIJO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_PREFIJO" Precision="0" ProviderType="Varchar2" Scale="0" Size="3" SourceColumn="PREFIJO" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO "PRO_TIPOPRODUCTO" ("IDTIPOPRODUCTO", "DESCRIPCION", "PREFIJO") VALUES (:IDTIPOPRODUCTO, :DESCRIPCION, :PREFIJO)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDTIPOPRODUCTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="6" SourceColumn="IDTIPOPRODUCTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="DESCRIPCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="PREFIJO" Precision="0" ProviderType="Varchar2" Scale="0" Size="3" SourceColumn="PREFIJO" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     IDTIPOPRODUCTO, DESCRIPCION, PREFIJO
FROM         PRO_TIPOPRODUCTO
ORDER BY IDTIPOPRODUCTO</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE "PRO_TIPOPRODUCTO" SET "IDTIPOPRODUCTO" = :IDTIPOPRODUCTO, "DESCRIPCION" = :DESCRIPCION, "PREFIJO" = :PREFIJO WHERE (("IDTIPOPRODUCTO" = :Original_IDTIPOPRODUCTO) AND ((:IsNull_DESCRIPCION = 1 AND "DESCRIPCION" IS NULL) OR ("DESCRIPCION" = :Original_DESCRIPCION)) AND ((:IsNull_PREFIJO = 1 AND "PREFIJO" IS NULL) OR ("PREFIJO" = :Original_PREFIJO)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDTIPOPRODUCTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="6" SourceColumn="IDTIPOPRODUCTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="DESCRIPCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="PREFIJO" Precision="0" ProviderType="Varchar2" Scale="0" Size="3" SourceColumn="PREFIJO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDTIPOPRODUCTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="6" SourceColumn="IDTIPOPRODUCTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_DESCRIPCION" Precision="0" ProviderType="Int32" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_DESCRIPCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_PREFIJO" Precision="0" ProviderType="Int32" Scale="0" Size="3" SourceColumn="PREFIJO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_PREFIJO" Precision="0" ProviderType="Varchar2" Scale="0" Size="3" SourceColumn="PREFIJO" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDTIPOPRODUCTO" DataSetColumn="IDTIPOPRODUCTO" />
              <Mapping SourceColumn="DESCRIPCION" DataSetColumn="DESCRIPCION" />
              <Mapping SourceColumn="PREFIJO" DataSetColumn="PREFIJO" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.PRO_TIPOPRODUCTO" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByidTipoProd" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByidTipoProd" GeneratorSourceName="FillByidTipoProd" GetMethodModifier="Public" GetMethodName="GetDataByidTipoProd" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByidTipoProd" UserSourceName="FillByidTipoProd">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT DESCRIPCION, IDTIPOPRODUCTO, PREFIJO FROM PRO_TIPOPRODUCTO WHERE (IDTIPOPRODUCTO = :IDTIPOPROD)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="IDTIPOPROD" ColumnName="IDTIPOPRODUCTO" DataSourceName="SAMUEL.PRO_TIPOPRODUCTO" DataTypeServer="VARCHAR2(5)" DbType="String" Direction="Input" ParameterName=":IDTIPOPROD" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDTIPOPRODUCTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.PRO_TIPOPRODUCTO" DbObjectType="Table" GenerateShortCommands="true" GeneratorSourceName="GetNombreTipo" Modifier="Public" Name="GetNombreTipo" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="GetNombreTipo">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        DESCRIPCION
FROM            PRO_TIPOPRODUCTO
WHERE        (IDTIPOPRODUCTO = :pIDTIPOPROD)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="pIDTIPOPROD" ColumnName="IDTIPOPRODUCTO" DataSourceName="SAMUEL.PRO_TIPOPRODUCTO" DataTypeServer="VARCHAR2(5)" DbType="String" Direction="Input" ParameterName=":pIDTIPOPROD" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDTIPOPRODUCTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PRO_ENCALISTAPRECIOSTableAdapter" GeneratorDataComponentClassName="PRO_ENCALISTAPRECIOSTableAdapter" Name="PRO_ENCALISTAPRECIOS" UserDataComponentName="PRO_ENCALISTAPRECIOSTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.PRO_ENCALISTAPRECIOS" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM "PRO_ENCALISTAPRECIOS" WHERE (("IDLISTA" = :Original_IDLISTA) AND ((:IsNull_DESCRIPCION = 1 AND "DESCRIPCION" IS NULL) OR ("DESCRIPCION" = :Original_DESCRIPCION)) AND ((:IsNull_ESTADO = 1 AND "ESTADO" IS NULL) OR ("ESTADO" = :Original_ESTADO)) AND ((:IsNull_TIPOLISTA = 1 AND "TIPOLISTA" IS NULL) OR ("TIPOLISTA" = :Original_TIPOLISTA)) AND ((:IsNull_FECHAINI = 1 AND "FECHAINI" IS NULL) OR ("FECHAINI" = :Original_FECHAINI)) AND ((:IsNull_FECHAFIN = 1 AND "FECHAFIN" IS NULL) OR ("FECHAFIN" = :Original_FECHAFIN)) AND ((:IsNull_COSTOPRECIO = 1 AND "COSTOPRECIO" IS NULL) OR ("COSTOPRECIO" = :Original_COSTOPRECIO)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDLISTA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDLISTA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_DESCRIPCION" Precision="0" ProviderType="Int32" Scale="0" Size="20" SourceColumn="DESCRIPCION" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_DESCRIPCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="DESCRIPCION" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ESTADO" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="ESTADO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_ESTADO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="ESTADO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_TIPOLISTA" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="TIPOLISTA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_TIPOLISTA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="TIPOLISTA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_FECHAINI" Precision="0" ProviderType="Int32" Scale="0" Size="7" SourceColumn="FECHAINI" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="Original_FECHAINI" Precision="0" ProviderType="Date" Scale="0" Size="7" SourceColumn="FECHAINI" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_FECHAFIN" Precision="0" ProviderType="Int32" Scale="0" Size="7" SourceColumn="FECHAFIN" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="Original_FECHAFIN" Precision="0" ProviderType="Date" Scale="0" Size="7" SourceColumn="FECHAFIN" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_COSTOPRECIO" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="COSTOPRECIO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_COSTOPRECIO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="COSTOPRECIO" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO "PRO_ENCALISTAPRECIOS" ("IDLISTA", "DESCRIPCION", "ESTADO", "TIPOLISTA", "FECHAINI", "FECHAFIN", "COSTOPRECIO") VALUES (:IDLISTA, :DESCRIPCION, :ESTADO, :TIPOLISTA, :FECHAINI, :FECHAFIN, :COSTOPRECIO)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDLISTA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDLISTA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="DESCRIPCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="DESCRIPCION" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="ESTADO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="ESTADO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="TIPOLISTA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="TIPOLISTA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="FECHAINI" Precision="0" ProviderType="Date" Scale="0" Size="7" SourceColumn="FECHAINI" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="FECHAFIN" Precision="0" ProviderType="Date" Scale="0" Size="7" SourceColumn="FECHAFIN" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="COSTOPRECIO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="COSTOPRECIO" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        IDLISTA, DESCRIPCION, ESTADO, TIPOLISTA, FECHAINI, FECHAFIN, COSTOPRECIO
FROM            PRO_ENCALISTAPRECIOS</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE "PRO_ENCALISTAPRECIOS" SET "IDLISTA" = :IDLISTA, "DESCRIPCION" = :DESCRIPCION, "ESTADO" = :ESTADO, "TIPOLISTA" = :TIPOLISTA, "FECHAINI" = :FECHAINI, "FECHAFIN" = :FECHAFIN, "COSTOPRECIO" = :COSTOPRECIO WHERE (("IDLISTA" = :Original_IDLISTA) AND ((:IsNull_DESCRIPCION = 1 AND "DESCRIPCION" IS NULL) OR ("DESCRIPCION" = :Original_DESCRIPCION)) AND ((:IsNull_ESTADO = 1 AND "ESTADO" IS NULL) OR ("ESTADO" = :Original_ESTADO)) AND ((:IsNull_TIPOLISTA = 1 AND "TIPOLISTA" IS NULL) OR ("TIPOLISTA" = :Original_TIPOLISTA)) AND ((:IsNull_FECHAINI = 1 AND "FECHAINI" IS NULL) OR ("FECHAINI" = :Original_FECHAINI)) AND ((:IsNull_FECHAFIN = 1 AND "FECHAFIN" IS NULL) OR ("FECHAFIN" = :Original_FECHAFIN)) AND ((:IsNull_COSTOPRECIO = 1 AND "COSTOPRECIO" IS NULL) OR ("COSTOPRECIO" = :Original_COSTOPRECIO)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDLISTA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDLISTA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="DESCRIPCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="DESCRIPCION" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="ESTADO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="ESTADO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="TIPOLISTA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="TIPOLISTA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="FECHAINI" Precision="0" ProviderType="Date" Scale="0" Size="7" SourceColumn="FECHAINI" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="FECHAFIN" Precision="0" ProviderType="Date" Scale="0" Size="7" SourceColumn="FECHAFIN" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="COSTOPRECIO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="COSTOPRECIO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDLISTA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDLISTA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_DESCRIPCION" Precision="0" ProviderType="Int32" Scale="0" Size="20" SourceColumn="DESCRIPCION" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_DESCRIPCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="DESCRIPCION" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ESTADO" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="ESTADO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_ESTADO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="ESTADO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_TIPOLISTA" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="TIPOLISTA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_TIPOLISTA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="TIPOLISTA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_FECHAINI" Precision="0" ProviderType="Int32" Scale="0" Size="7" SourceColumn="FECHAINI" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="Original_FECHAINI" Precision="0" ProviderType="Date" Scale="0" Size="7" SourceColumn="FECHAINI" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_FECHAFIN" Precision="0" ProviderType="Int32" Scale="0" Size="7" SourceColumn="FECHAFIN" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="Original_FECHAFIN" Precision="0" ProviderType="Date" Scale="0" Size="7" SourceColumn="FECHAFIN" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_COSTOPRECIO" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="COSTOPRECIO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_COSTOPRECIO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="COSTOPRECIO" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDLISTA" DataSetColumn="IDLISTA" />
              <Mapping SourceColumn="DESCRIPCION" DataSetColumn="DESCRIPCION" />
              <Mapping SourceColumn="ESTADO" DataSetColumn="ESTADO" />
              <Mapping SourceColumn="TIPOLISTA" DataSetColumn="TIPOLISTA" />
              <Mapping SourceColumn="FECHAINI" DataSetColumn="FECHAINI" />
              <Mapping SourceColumn="FECHAFIN" DataSetColumn="FECHAFIN" />
              <Mapping SourceColumn="COSTOPRECIO" DataSetColumn="COSTOPRECIO" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.PRO_ENCALISTAPRECIOS" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByIdLista" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByIdLista" GeneratorSourceName="FillByIdLista" GetMethodModifier="Public" GetMethodName="GetDataByIdLista" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByIdLista" UserSourceName="FillByIdLista">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT COSTOPRECIO, DESCRIPCION, ESTADO, FECHAFIN, FECHAINI, IDLISTA, TIPOLISTA FROM PRO_ENCALISTAPRECIOS WHERE (IDLISTA = :PIDLISTA)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="PIDLISTA" ColumnName="IDLISTA" DataSourceName="SAMUEL.PRO_ENCALISTAPRECIOS" DataTypeServer="VARCHAR2(5)" DbType="String" Direction="Input" ParameterName=":PIDLISTA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDLISTA" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.PRO_ENCALISTAPRECIOS" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByIdProducto" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByIdProducto" GeneratorSourceName="FillByIdProducto" GetMethodModifier="Public" GetMethodName="GetDataByIdProducto" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByIdProducto" UserSourceName="FillByIdProducto">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT COSTOPRECIO, DESCRIPCION, ESTADO, FECHAFIN, FECHAINI, IDLISTA, TIPOLISTA FROM PRO_ENCALISTAPRECIOS WHERE (IDLISTA = :pIDLISTA)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="pIDLISTA" ColumnName="IDLISTA" DataSourceName="SAMUEL.PRO_ENCALISTAPRECIOS" DataTypeServer="VARCHAR2(5)" DbType="String" Direction="Input" ParameterName=":pIDLISTA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDLISTA" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.PRO_ENCALISTAPRECIOS" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByTipoLista" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByTipoLista" GeneratorSourceName="FillByTipoLista" GetMethodModifier="Public" GetMethodName="GetDataByTipoLista" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByTipoLista" UserSourceName="FillByTipoLista">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT COSTOPRECIO, DESCRIPCION, ESTADO, FECHAFIN, FECHAINI, IDLISTA, TIPOLISTA FROM PRO_ENCALISTAPRECIOS WHERE (TIPOLISTA = :PTIPOLISTA)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="PTIPOLISTA" ColumnName="TIPOLISTA" DataSourceName="SAMUEL.PRO_ENCALISTAPRECIOS" DataTypeServer="NUMBER(22)" DbType="Decimal" Direction="Input" ParameterName=":PTIPOLISTA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="TIPOLISTA" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.PRO_ENCALISTAPRECIOS" DbObjectType="Table" GenerateShortCommands="true" GeneratorSourceName="GetNombreLista" Modifier="Public" Name="GetNombreLista" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="GetNombreLista">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        DESCRIPCION
FROM            PRO_ENCALISTAPRECIOS
WHERE        (IDLISTA = :pIDLISTA)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="pIDLISTA" ColumnName="IDLISTA" DataSourceName="SAMUEL.PRO_ENCALISTAPRECIOS" DataTypeServer="VARCHAR2(5)" DbType="String" Direction="Input" ParameterName=":pIDLISTA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDLISTA" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PRO_DETALLELISTAPRECIOSTableAdapter" GeneratorDataComponentClassName="PRO_DETALLELISTAPRECIOSTableAdapter" Name="PRO_DETALLELISTAPRECIOS" UserDataComponentName="PRO_DETALLELISTAPRECIOSTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.PRO_DETALLELISTAPRECIOS" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM "PRO_DETALLELISTAPRECIOS" WHERE (("IDLISTA" = :Original_IDLISTA) AND ("IDPRODUCTO" = :Original_IDPRODUCTO) AND ((:IsNull_PRECIOVENTA = 1 AND "PRECIOVENTA" IS NULL) OR ("PRECIOVENTA" = :Original_PRECIOVENTA)) AND ((:IsNull_PRECIOCOMPRA = 1 AND "PRECIOCOMPRA" IS NULL) OR ("PRECIOCOMPRA" = :Original_PRECIOCOMPRA)) AND ("FECHACREACION" = :Original_FECHACREACION) AND ((:IsNull_FECHAVENC = 1 AND "FECHAVENC" IS NULL) OR ("FECHAVENC" = :Original_FECHAVENC)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDLISTA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDLISTA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDPRODUCTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="IDPRODUCTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_PRECIOVENTA" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="PRECIOVENTA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_PRECIOVENTA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="PRECIOVENTA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_PRECIOCOMPRA" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="PRECIOCOMPRA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_PRECIOCOMPRA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="PRECIOCOMPRA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="Original_FECHACREACION" Precision="0" ProviderType="Date" Scale="0" Size="7" SourceColumn="FECHACREACION" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_FECHAVENC" Precision="0" ProviderType="Int32" Scale="0" Size="7" SourceColumn="FECHAVENC" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="Original_FECHAVENC" Precision="0" ProviderType="Date" Scale="0" Size="7" SourceColumn="FECHAVENC" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO "PRO_DETALLELISTAPRECIOS" ("IDLISTA", "IDPRODUCTO", "PRECIOVENTA", "PRECIOCOMPRA", "FECHACREACION", "FECHAVENC") VALUES (:IDLISTA, :IDPRODUCTO, :PRECIOVENTA, :PRECIOCOMPRA, :FECHACREACION, :FECHAVENC)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDLISTA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDLISTA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDPRODUCTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="IDPRODUCTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="PRECIOVENTA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="PRECIOVENTA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="PRECIOCOMPRA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="PRECIOCOMPRA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="FECHACREACION" Precision="0" ProviderType="Date" Scale="0" Size="7" SourceColumn="FECHACREACION" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="FECHAVENC" Precision="0" ProviderType="Date" Scale="0" Size="7" SourceColumn="FECHAVENC" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        IDLISTA, IDPRODUCTO, PRECIOVENTA, PRECIOCOMPRA, FECHACREACION, FECHAVENC
FROM            PRO_DETALLELISTAPRECIOS</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE "PRO_DETALLELISTAPRECIOS" SET "IDLISTA" = :IDLISTA, "IDPRODUCTO" = :IDPRODUCTO, "PRECIOVENTA" = :PRECIOVENTA, "PRECIOCOMPRA" = :PRECIOCOMPRA, "FECHACREACION" = :FECHACREACION, "FECHAVENC" = :FECHAVENC WHERE (("IDLISTA" = :Original_IDLISTA) AND ("IDPRODUCTO" = :Original_IDPRODUCTO) AND ((:IsNull_PRECIOVENTA = 1 AND "PRECIOVENTA" IS NULL) OR ("PRECIOVENTA" = :Original_PRECIOVENTA)) AND ((:IsNull_PRECIOCOMPRA = 1 AND "PRECIOCOMPRA" IS NULL) OR ("PRECIOCOMPRA" = :Original_PRECIOCOMPRA)) AND ("FECHACREACION" = :Original_FECHACREACION) AND ((:IsNull_FECHAVENC = 1 AND "FECHAVENC" IS NULL) OR ("FECHAVENC" = :Original_FECHAVENC)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDLISTA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDLISTA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDPRODUCTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="IDPRODUCTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="PRECIOVENTA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="PRECIOVENTA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="PRECIOCOMPRA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="PRECIOCOMPRA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="FECHACREACION" Precision="0" ProviderType="Date" Scale="0" Size="7" SourceColumn="FECHACREACION" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="FECHAVENC" Precision="0" ProviderType="Date" Scale="0" Size="7" SourceColumn="FECHAVENC" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDLISTA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDLISTA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDPRODUCTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="IDPRODUCTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_PRECIOVENTA" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="PRECIOVENTA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_PRECIOVENTA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="PRECIOVENTA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_PRECIOCOMPRA" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="PRECIOCOMPRA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_PRECIOCOMPRA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="PRECIOCOMPRA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="Original_FECHACREACION" Precision="0" ProviderType="Date" Scale="0" Size="7" SourceColumn="FECHACREACION" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_FECHAVENC" Precision="0" ProviderType="Int32" Scale="0" Size="7" SourceColumn="FECHAVENC" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="Original_FECHAVENC" Precision="0" ProviderType="Date" Scale="0" Size="7" SourceColumn="FECHAVENC" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDLISTA" DataSetColumn="IDLISTA" />
              <Mapping SourceColumn="IDPRODUCTO" DataSetColumn="IDPRODUCTO" />
              <Mapping SourceColumn="PRECIOVENTA" DataSetColumn="PRECIOVENTA" />
              <Mapping SourceColumn="PRECIOCOMPRA" DataSetColumn="PRECIOCOMPRA" />
              <Mapping SourceColumn="FECHACREACION" DataSetColumn="FECHACREACION" />
              <Mapping SourceColumn="FECHAVENC" DataSetColumn="FECHAVENC" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.PRO_DETALLELISTAPRECIOS" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByIdLista" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByIdLista" GeneratorSourceName="FillByIdLista" GetMethodModifier="Public" GetMethodName="GetDataByIdLista" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByIdLista" UserSourceName="FillByIdLista">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT FECHACREACION, FECHAVENC, IDLISTA, IDPRODUCTO, PRECIOCOMPRA, PRECIOVENTA FROM PRO_DETALLELISTAPRECIOS WHERE (IDLISTA = :pIDLISTA) AND FECHAVENC IS NULL</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="pIDLISTA" ColumnName="IDLISTA" DataSourceName="SAMUEL.PRO_DETALLELISTAPRECIOS" DataTypeServer="VARCHAR2(5)" DbType="String" Direction="Input" ParameterName=":pIDLISTA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDLISTA" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.PRO_DETALLELISTAPRECIOS" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByIdListaIdProducto" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByIdListaIdProducto" GeneratorSourceName="FillByIdListaIdProducto" GetMethodModifier="Public" GetMethodName="GetDataByIdListaIdProducto" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByIdListaIdProducto" UserSourceName="FillByIdListaIdProducto">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT FECHACREACION, FECHAVENC, IDLISTA, IDPRODUCTO, PRECIOCOMPRA, PRECIOVENTA FROM PRO_DETALLELISTAPRECIOS WHERE (IDLISTA = :PIDLISTA) AND (IDPRODUCTO = :PIDPRODUCTO)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="PIDLISTA" ColumnName="IDLISTA" DataSourceName="SAMUEL.PRO_DETALLELISTAPRECIOS" DataTypeServer="VARCHAR2(5)" DbType="String" Direction="Input" ParameterName=":PIDLISTA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDLISTA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="PIDPRODUCTO" ColumnName="IDPRODUCTO" DataSourceName="SAMUEL.PRO_DETALLELISTAPRECIOS" DataTypeServer="VARCHAR2(20)" DbType="String" Direction="Input" ParameterName=":PIDPRODUCTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="IDPRODUCTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.PRO_DETALLELISTAPRECIOS" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByIdListaIdProductoActual" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByIdListaIdProductoActual" GeneratorSourceName="FillByIdListaIdProductoActual" GetMethodModifier="Public" GetMethodName="GetDataByIdListaIdProductoActual" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByIdListaIdProductoActual" UserSourceName="FillByIdListaIdProductoActual">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        IDLISTA, IDPRODUCTO, PRECIOVENTA, PRECIOCOMPRA, FECHACREACION, FECHAVENC
FROM            PRO_DETALLELISTAPRECIOS
WHERE        (IDLISTA = :IDLISTA) AND (IDPRODUCTO = :IDPRODUCTO) AND (FECHAVENC IS NULL)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="IDLISTA" ColumnName="IDLISTA" DataSourceName="SAMUEL.PRO_DETALLELISTAPRECIOS" DataTypeServer="VARCHAR2(5)" DbType="String" Direction="Input" ParameterName=":IDLISTA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDLISTA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="IDPRODUCTO" ColumnName="IDPRODUCTO" DataSourceName="SAMUEL.PRO_DETALLELISTAPRECIOS" DataTypeServer="VARCHAR2(20)" DbType="String" Direction="Input" ParameterName=":IDPRODUCTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="IDPRODUCTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PRO_CLASETableAdapter" GeneratorDataComponentClassName="PRO_CLASETableAdapter" Name="PRO_CLASE" UserDataComponentName="PRO_CLASETableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.PRO_CLASE" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM "PRO_CLASE" WHERE (("IDCLASE" = :Original_IDCLASE) AND ((:IsNull_DESCRIPCION = 1 AND "DESCRIPCION" IS NULL) OR ("DESCRIPCION" = :Original_DESCRIPCION)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDCLASE" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDCLASE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_DESCRIPCION" Precision="0" ProviderType="Int32" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_DESCRIPCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO "PRO_CLASE" ("IDCLASE", "DESCRIPCION") VALUES (:IDCLASE, :DESCRIPCION)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDCLASE" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDCLASE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="DESCRIPCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     IDCLASE, DESCRIPCION
FROM         PRO_CLASE
ORDER BY IDCLASE</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE "PRO_CLASE" SET "IDCLASE" = :IDCLASE, "DESCRIPCION" = :DESCRIPCION WHERE (("IDCLASE" = :Original_IDCLASE) AND ((:IsNull_DESCRIPCION = 1 AND "DESCRIPCION" IS NULL) OR ("DESCRIPCION" = :Original_DESCRIPCION)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDCLASE" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDCLASE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="DESCRIPCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDCLASE" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDCLASE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_DESCRIPCION" Precision="0" ProviderType="Int32" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_DESCRIPCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDCLASE" DataSetColumn="IDCLASE" />
              <Mapping SourceColumn="DESCRIPCION" DataSetColumn="DESCRIPCION" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.PRO_CLASE" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByIdClase" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByIdClase" GeneratorSourceName="FillByIdClase" GetMethodModifier="Public" GetMethodName="GetDataByIdClase" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByIdClase" UserSourceName="FillByIdClase">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT DESCRIPCION, IDCLASE FROM PRO_CLASE WHERE (IDCLASE = :PIDCLASE)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="PIDCLASE" ColumnName="IDCLASE" DataSourceName="SAMUEL.PRO_CLASE" DataTypeServer="VARCHAR2(5)" DbType="String" Direction="Input" ParameterName=":PIDCLASE" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDCLASE" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PRO_MARCASTableAdapter" GeneratorDataComponentClassName="PRO_MARCASTableAdapter" Name="PRO_MARCAS" UserDataComponentName="PRO_MARCASTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.PRO_MARCAS" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM "PRO_MARCAS" WHERE (("IDMARCA" = :Original_IDMARCA) AND ((:IsNull_DESCRIPCION = 1 AND "DESCRIPCION" IS NULL) OR ("DESCRIPCION" = :Original_DESCRIPCION)) AND ((:IsNull_PREFIJO = 1 AND "PREFIJO" IS NULL) OR ("PREFIJO" = :Original_PREFIJO)) AND ((:IsNull_DIJITOSCONSEC = 1 AND "DIJITOSCONSEC" IS NULL) OR ("DIJITOSCONSEC" = :Original_DIJITOSCONSEC)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDMARCA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDMARCA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_DESCRIPCION" Precision="0" ProviderType="Int32" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_DESCRIPCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_PREFIJO" Precision="0" ProviderType="Int32" Scale="0" Size="3" SourceColumn="PREFIJO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_PREFIJO" Precision="0" ProviderType="Varchar2" Scale="0" Size="3" SourceColumn="PREFIJO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_DIJITOSCONSEC" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="DIJITOSCONSEC" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_DIJITOSCONSEC" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="DIJITOSCONSEC" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO "PRO_MARCAS" ("IDMARCA", "DESCRIPCION", "PREFIJO", "DIJITOSCONSEC") VALUES (:IDMARCA, :DESCRIPCION, :PREFIJO, :DIJITOSCONSEC)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDMARCA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDMARCA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="DESCRIPCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="PREFIJO" Precision="0" ProviderType="Varchar2" Scale="0" Size="3" SourceColumn="PREFIJO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="DIJITOSCONSEC" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="DIJITOSCONSEC" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     IDMARCA, DESCRIPCION, PREFIJO, DIJITOSCONSEC
FROM         PRO_MARCAS
ORDER BY IDMARCA</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE "PRO_MARCAS" SET "IDMARCA" = :IDMARCA, "DESCRIPCION" = :DESCRIPCION, "PREFIJO" = :PREFIJO, "DIJITOSCONSEC" = :DIJITOSCONSEC WHERE (("IDMARCA" = :Original_IDMARCA) AND ((:IsNull_DESCRIPCION = 1 AND "DESCRIPCION" IS NULL) OR ("DESCRIPCION" = :Original_DESCRIPCION)) AND ((:IsNull_PREFIJO = 1 AND "PREFIJO" IS NULL) OR ("PREFIJO" = :Original_PREFIJO)) AND ((:IsNull_DIJITOSCONSEC = 1 AND "DIJITOSCONSEC" IS NULL) OR ("DIJITOSCONSEC" = :Original_DIJITOSCONSEC)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDMARCA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDMARCA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="DESCRIPCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="PREFIJO" Precision="0" ProviderType="Varchar2" Scale="0" Size="3" SourceColumn="PREFIJO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="DIJITOSCONSEC" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="DIJITOSCONSEC" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDMARCA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDMARCA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_DESCRIPCION" Precision="0" ProviderType="Int32" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_DESCRIPCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_PREFIJO" Precision="0" ProviderType="Int32" Scale="0" Size="3" SourceColumn="PREFIJO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_PREFIJO" Precision="0" ProviderType="Varchar2" Scale="0" Size="3" SourceColumn="PREFIJO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_DIJITOSCONSEC" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="DIJITOSCONSEC" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_DIJITOSCONSEC" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="DIJITOSCONSEC" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDMARCA" DataSetColumn="IDMARCA" />
              <Mapping SourceColumn="DESCRIPCION" DataSetColumn="DESCRIPCION" />
              <Mapping SourceColumn="PREFIJO" DataSetColumn="PREFIJO" />
              <Mapping SourceColumn="DIJITOSCONSEC" DataSetColumn="DIJITOSCONSEC" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.PRO_MARCAS" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByIdMaraca" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByIdMaraca" GeneratorSourceName="FillByIdMaraca" GetMethodModifier="Public" GetMethodName="GetDataByIdMaraca" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByIdMaraca" UserSourceName="FillByIdMaraca">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT DESCRIPCION, DIJITOSCONSEC, IDMARCA, PREFIJO FROM PRO_MARCAS WHERE (IDMARCA = :PIDMARCA)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="PIDMARCA" ColumnName="IDMARCA" DataSourceName="SAMUEL.PRO_MARCAS" DataTypeServer="VARCHAR2(5)" DbType="String" Direction="Input" ParameterName=":PIDMARCA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDMARCA" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="dsProductos" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="dsProductos" msprop:Generator_DataSetName="dsProductos" msprop:EnableTableAdapterManager="true">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="PRO_PLANES" msprop:Generator_UserTableName="PRO_PLANES" msprop:Generator_RowDeletedName="PRO_PLANESRowDeleted" msprop:Generator_RowChangedName="PRO_PLANESRowChanged" msprop:Generator_RowClassName="PRO_PLANESRow" msprop:Generator_RowChangingName="PRO_PLANESRowChanging" msprop:Generator_RowEvArgName="PRO_PLANESRowChangeEvent" msprop:Generator_RowEvHandlerName="PRO_PLANESRowChangeEventHandler" msprop:Generator_TableClassName="PRO_PLANESDataTable" msprop:Generator_TableVarName="tablePRO_PLANES" msprop:Generator_RowDeletingName="PRO_PLANESRowDeleting" msprop:Generator_TablePropName="PRO_PLANES">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDPLAN" msprop:Generator_UserColumnName="IDPLAN" msprop:Generator_ColumnVarNameInTable="columnIDPLAN" msprop:Generator_ColumnPropNameInRow="IDPLAN" msprop:Generator_ColumnPropNameInTable="IDPLANColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DESCRIPCION" msprop:Generator_UserColumnName="DESCRIPCION" msprop:Generator_ColumnVarNameInTable="columnDESCRIPCION" msprop:Generator_ColumnPropNameInRow="DESCRIPCION" msprop:Generator_ColumnPropNameInTable="DESCRIPCIONColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="COMISION" msprop:Generator_UserColumnName="COMISION" msprop:Generator_ColumnVarNameInTable="columnCOMISION" msprop:Generator_ColumnPropNameInRow="COMISION" msprop:Generator_ColumnPropNameInTable="COMISIONColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="VALORBASE" msprop:Generator_UserColumnName="VALORBASE" msprop:Generator_ColumnVarNameInTable="columnVALORBASE" msprop:Generator_ColumnPropNameInRow="VALORBASE" msprop:Generator_ColumnPropNameInTable="VALORBASEColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="VALORIVA" msprop:Generator_UserColumnName="VALORIVA" msprop:Generator_ColumnVarNameInTable="columnVALORIVA" msprop:Generator_ColumnPropNameInRow="VALORIVA" msprop:Generator_ColumnPropNameInTable="VALORIVAColumn" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="PRO_PRODUCTO" msprop:Generator_UserTableName="PRO_PRODUCTO" msprop:Generator_RowDeletedName="PRO_PRODUCTORowDeleted" msprop:Generator_RowChangedName="PRO_PRODUCTORowChanged" msprop:Generator_RowClassName="PRO_PRODUCTORow" msprop:Generator_RowChangingName="PRO_PRODUCTORowChanging" msprop:Generator_RowEvArgName="PRO_PRODUCTORowChangeEvent" msprop:Generator_RowEvHandlerName="PRO_PRODUCTORowChangeEventHandler" msprop:Generator_TableClassName="PRO_PRODUCTODataTable" msprop:Generator_TableVarName="tablePRO_PRODUCTO" msprop:Generator_RowDeletingName="PRO_PRODUCTORowDeleting" msprop:Generator_TablePropName="PRO_PRODUCTO">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDPRODUCTO" msprop:Generator_UserColumnName="IDPRODUCTO" msprop:Generator_ColumnVarNameInTable="columnIDPRODUCTO" msprop:Generator_ColumnPropNameInRow="IDPRODUCTO" msprop:Generator_ColumnPropNameInTable="IDPRODUCTOColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DESCRICION" msprop:Generator_UserColumnName="DESCRICION" msprop:Generator_ColumnVarNameInTable="columnDESCRICION" msprop:Generator_ColumnPropNameInRow="DESCRICION" msprop:Generator_ColumnPropNameInTable="DESCRICIONColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="APLICARANGODTO" msprop:Generator_UserColumnName="APLICARANGODTO" msprop:Generator_ColumnVarNameInTable="columnAPLICARANGODTO" msprop:Generator_ColumnPropNameInRow="APLICARANGODTO" msprop:Generator_ColumnPropNameInTable="APLICARANGODTOColumn" default="N" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CONTENIDO" msprop:Generator_UserColumnName="CONTENIDO" msprop:Generator_ColumnVarNameInTable="columnCONTENIDO" msprop:Generator_ColumnPropNameInRow="CONTENIDO" msprop:Generator_ColumnPropNameInTable="CONTENIDOColumn" type="xs:decimal" default="0" minOccurs="0" />
              <xs:element name="COSTO" msprop:Generator_UserColumnName="COSTO" msprop:Generator_ColumnVarNameInTable="columnCOSTO" msprop:Generator_ColumnPropNameInRow="COSTO" msprop:Generator_ColumnPropNameInTable="COSTOColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="EAN" msprop:Generator_UserColumnName="EAN" msprop:Generator_ColumnVarNameInTable="columnEAN" msprop:Generator_ColumnPropNameInRow="EAN" msprop:Generator_ColumnPropNameInTable="EANColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ESTADO" msprop:Generator_UserColumnName="ESTADO" msprop:Generator_ColumnVarNameInTable="columnESTADO" msprop:Generator_ColumnPropNameInRow="ESTADO" msprop:Generator_ColumnPropNameInTable="ESTADOColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="IDTIPOIVA" msprop:Generator_UserColumnName="IDTIPOIVA" msprop:Generator_ColumnVarNameInTable="columnIDTIPOIVA" msprop:Generator_ColumnPropNameInRow="IDTIPOIVA" msprop:Generator_ColumnPropNameInTable="IDTIPOIVAColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IDTIPOPRODUCTO" msprop:Generator_UserColumnName="IDTIPOPRODUCTO" msprop:Generator_ColumnVarNameInTable="columnIDTIPOPRODUCTO" msprop:Generator_ColumnPropNameInRow="IDTIPOPRODUCTO" msprop:Generator_ColumnPropNameInTable="IDTIPOPRODUCTOColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="6" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="REFERENCIA" msprop:Generator_UserColumnName="REFERENCIA" msprop:Generator_ColumnVarNameInTable="columnREFERENCIA" msprop:Generator_ColumnPropNameInRow="REFERENCIA" msprop:Generator_ColumnPropNameInTable="REFERENCIAColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="UNIDAD" msprop:Generator_UserColumnName="UNIDAD" msprop:Generator_ColumnVarNameInTable="columnUNIDAD" msprop:Generator_ColumnPropNameInRow="UNIDAD" msprop:Generator_ColumnPropNameInTable="UNIDADColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IDMARCA" msprop:Generator_UserColumnName="IDMARCA" msprop:Generator_ColumnVarNameInTable="columnIDMARCA" msprop:Generator_ColumnPropNameInRow="IDMARCA" msprop:Generator_ColumnPropNameInTable="IDMARCAColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IDCLASE" msprop:Generator_UserColumnName="IDCLASE" msprop:Generator_ColumnVarNameInTable="columnIDCLASE" msprop:Generator_ColumnPropNameInRow="IDCLASE" msprop:Generator_ColumnPropNameInTable="IDCLASEColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ESPADRE" msprop:Generator_UserColumnName="ESPADRE" msprop:Generator_ColumnPropNameInRow="ESPADRE" msprop:Generator_ColumnVarNameInTable="columnESPADRE" msprop:Generator_ColumnPropNameInTable="ESPADREColumn" default="N" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TIPOSUBPROD" msprop:Generator_UserColumnName="TIPOSUBPROD" msprop:Generator_ColumnVarNameInTable="columnTIPOSUBPROD" msprop:Generator_ColumnPropNameInRow="TIPOSUBPROD" msprop:Generator_ColumnPropNameInTable="TIPOSUBPRODColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="CANTIDADSUBPROD" msprop:Generator_UserColumnName="CANTIDADSUBPROD" msprop:Generator_ColumnPropNameInRow="CANTIDADSUBPROD" msprop:Generator_ColumnVarNameInTable="columnCANTIDADSUBPROD" msprop:Generator_ColumnPropNameInTable="CANTIDADSUBPRODColumn" type="xs:decimal" default="0" minOccurs="0" />
              <xs:element name="ICCIDENCOMPRAS" msprop:Generator_UserColumnName="ICCIDENCOMPRAS" msprop:Generator_ColumnPropNameInRow="ICCIDENCOMPRAS" msprop:Generator_ColumnVarNameInTable="columnICCIDENCOMPRAS" msprop:Generator_ColumnPropNameInTable="ICCIDENCOMPRASColumn" default="N" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IDPRODCONVIERTE" msprop:Generator_UserColumnName="IDPRODCONVIERTE" msprop:Generator_ColumnVarNameInTable="columnIDPRODCONVIERTE" msprop:Generator_ColumnPropNameInRow="IDPRODCONVIERTE" msprop:Generator_ColumnPropNameInTable="IDPRODCONVIERTEColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="PRO_TIPOPRODUCTO" msprop:Generator_UserTableName="PRO_TIPOPRODUCTO" msprop:Generator_RowDeletedName="PRO_TIPOPRODUCTORowDeleted" msprop:Generator_RowChangedName="PRO_TIPOPRODUCTORowChanged" msprop:Generator_RowClassName="PRO_TIPOPRODUCTORow" msprop:Generator_RowChangingName="PRO_TIPOPRODUCTORowChanging" msprop:Generator_RowEvArgName="PRO_TIPOPRODUCTORowChangeEvent" msprop:Generator_RowEvHandlerName="PRO_TIPOPRODUCTORowChangeEventHandler" msprop:Generator_TableClassName="PRO_TIPOPRODUCTODataTable" msprop:Generator_TableVarName="tablePRO_TIPOPRODUCTO" msprop:Generator_RowDeletingName="PRO_TIPOPRODUCTORowDeleting" msprop:Generator_TablePropName="PRO_TIPOPRODUCTO">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDTIPOPRODUCTO" msprop:Generator_UserColumnName="IDTIPOPRODUCTO" msprop:Generator_ColumnVarNameInTable="columnIDTIPOPRODUCTO" msprop:Generator_ColumnPropNameInRow="IDTIPOPRODUCTO" msprop:Generator_ColumnPropNameInTable="IDTIPOPRODUCTOColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="6" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DESCRIPCION" msprop:Generator_UserColumnName="DESCRIPCION" msprop:Generator_ColumnVarNameInTable="columnDESCRIPCION" msprop:Generator_ColumnPropNameInRow="DESCRIPCION" msprop:Generator_ColumnPropNameInTable="DESCRIPCIONColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PREFIJO" msprop:Generator_UserColumnName="PREFIJO" msprop:Generator_ColumnPropNameInRow="PREFIJO" msprop:Generator_ColumnVarNameInTable="columnPREFIJO" msprop:Generator_ColumnPropNameInTable="PREFIJOColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="PRO_ENCALISTAPRECIOS" msprop:Generator_UserTableName="PRO_ENCALISTAPRECIOS" msprop:Generator_RowDeletedName="PRO_ENCALISTAPRECIOSRowDeleted" msprop:Generator_RowChangedName="PRO_ENCALISTAPRECIOSRowChanged" msprop:Generator_RowClassName="PRO_ENCALISTAPRECIOSRow" msprop:Generator_RowChangingName="PRO_ENCALISTAPRECIOSRowChanging" msprop:Generator_RowEvArgName="PRO_ENCALISTAPRECIOSRowChangeEvent" msprop:Generator_RowEvHandlerName="PRO_ENCALISTAPRECIOSRowChangeEventHandler" msprop:Generator_TableClassName="PRO_ENCALISTAPRECIOSDataTable" msprop:Generator_TableVarName="tablePRO_ENCALISTAPRECIOS" msprop:Generator_RowDeletingName="PRO_ENCALISTAPRECIOSRowDeleting" msprop:Generator_TablePropName="PRO_ENCALISTAPRECIOS">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDLISTA" msprop:Generator_UserColumnName="IDLISTA" msprop:Generator_ColumnPropNameInRow="IDLISTA" msprop:Generator_ColumnVarNameInTable="columnIDLISTA" msprop:Generator_ColumnPropNameInTable="IDLISTAColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DESCRIPCION" msprop:Generator_UserColumnName="DESCRIPCION" msprop:Generator_ColumnPropNameInRow="DESCRIPCION" msprop:Generator_ColumnVarNameInTable="columnDESCRIPCION" msprop:Generator_ColumnPropNameInTable="DESCRIPCIONColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ESTADO" msprop:Generator_UserColumnName="ESTADO" msprop:Generator_ColumnPropNameInRow="ESTADO" msprop:Generator_ColumnVarNameInTable="columnESTADO" msprop:Generator_ColumnPropNameInTable="ESTADOColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="TIPOLISTA" msprop:Generator_UserColumnName="TIPOLISTA" msprop:Generator_ColumnPropNameInRow="TIPOLISTA" msprop:Generator_ColumnVarNameInTable="columnTIPOLISTA" msprop:Generator_ColumnPropNameInTable="TIPOLISTAColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="FECHAINI" msprop:Generator_UserColumnName="FECHAINI" msprop:Generator_ColumnPropNameInRow="FECHAINI" msprop:Generator_ColumnVarNameInTable="columnFECHAINI" msprop:Generator_ColumnPropNameInTable="FECHAINIColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="FECHAFIN" msprop:Generator_UserColumnName="FECHAFIN" msprop:Generator_ColumnPropNameInRow="FECHAFIN" msprop:Generator_ColumnVarNameInTable="columnFECHAFIN" msprop:Generator_ColumnPropNameInTable="FECHAFINColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="COSTOPRECIO" msprop:Generator_UserColumnName="COSTOPRECIO" msprop:Generator_ColumnPropNameInRow="COSTOPRECIO" msprop:Generator_ColumnVarNameInTable="columnCOSTOPRECIO" msprop:Generator_ColumnPropNameInTable="COSTOPRECIOColumn" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="PRO_DETALLELISTAPRECIOS" msprop:Generator_UserTableName="PRO_DETALLELISTAPRECIOS" msprop:Generator_RowDeletedName="PRO_DETALLELISTAPRECIOSRowDeleted" msprop:Generator_RowChangedName="PRO_DETALLELISTAPRECIOSRowChanged" msprop:Generator_RowClassName="PRO_DETALLELISTAPRECIOSRow" msprop:Generator_RowChangingName="PRO_DETALLELISTAPRECIOSRowChanging" msprop:Generator_RowEvArgName="PRO_DETALLELISTAPRECIOSRowChangeEvent" msprop:Generator_RowEvHandlerName="PRO_DETALLELISTAPRECIOSRowChangeEventHandler" msprop:Generator_TableClassName="PRO_DETALLELISTAPRECIOSDataTable" msprop:Generator_TableVarName="tablePRO_DETALLELISTAPRECIOS" msprop:Generator_RowDeletingName="PRO_DETALLELISTAPRECIOSRowDeleting" msprop:Generator_TablePropName="PRO_DETALLELISTAPRECIOS">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDLISTA" msprop:Generator_UserColumnName="IDLISTA" msprop:Generator_ColumnPropNameInRow="IDLISTA" msprop:Generator_ColumnVarNameInTable="columnIDLISTA" msprop:Generator_ColumnPropNameInTable="IDLISTAColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IDPRODUCTO" msprop:Generator_UserColumnName="IDPRODUCTO" msprop:Generator_ColumnPropNameInRow="IDPRODUCTO" msprop:Generator_ColumnVarNameInTable="columnIDPRODUCTO" msprop:Generator_ColumnPropNameInTable="IDPRODUCTOColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PRECIOVENTA" msprop:Generator_UserColumnName="PRECIOVENTA" msprop:Generator_ColumnVarNameInTable="columnPRECIOVENTA" msprop:Generator_ColumnPropNameInRow="PRECIOVENTA" msprop:Generator_ColumnPropNameInTable="PRECIOVENTAColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="PRECIOCOMPRA" msprop:Generator_UserColumnName="PRECIOCOMPRA" msprop:Generator_ColumnVarNameInTable="columnPRECIOCOMPRA" msprop:Generator_ColumnPropNameInRow="PRECIOCOMPRA" msprop:Generator_ColumnPropNameInTable="PRECIOCOMPRAColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="FECHACREACION" msprop:Generator_UserColumnName="FECHACREACION" msprop:Generator_ColumnVarNameInTable="columnFECHACREACION" msprop:Generator_ColumnPropNameInRow="FECHACREACION" msprop:Generator_ColumnPropNameInTable="FECHACREACIONColumn" type="xs:dateTime" />
              <xs:element name="FECHAVENC" msprop:Generator_UserColumnName="FECHAVENC" msprop:Generator_ColumnVarNameInTable="columnFECHAVENC" msprop:Generator_ColumnPropNameInRow="FECHAVENC" msprop:Generator_ColumnPropNameInTable="FECHAVENCColumn" type="xs:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="PRO_CLASE" msprop:Generator_UserTableName="PRO_CLASE" msprop:Generator_RowDeletedName="PRO_CLASERowDeleted" msprop:Generator_RowChangedName="PRO_CLASERowChanged" msprop:Generator_RowClassName="PRO_CLASERow" msprop:Generator_RowChangingName="PRO_CLASERowChanging" msprop:Generator_RowEvArgName="PRO_CLASERowChangeEvent" msprop:Generator_RowEvHandlerName="PRO_CLASERowChangeEventHandler" msprop:Generator_TableClassName="PRO_CLASEDataTable" msprop:Generator_TableVarName="tablePRO_CLASE" msprop:Generator_RowDeletingName="PRO_CLASERowDeleting" msprop:Generator_TablePropName="PRO_CLASE">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDCLASE" msprop:Generator_UserColumnName="IDCLASE" msprop:Generator_ColumnVarNameInTable="columnIDCLASE" msprop:Generator_ColumnPropNameInRow="IDCLASE" msprop:Generator_ColumnPropNameInTable="IDCLASEColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DESCRIPCION" msprop:Generator_UserColumnName="DESCRIPCION" msprop:Generator_ColumnVarNameInTable="columnDESCRIPCION" msprop:Generator_ColumnPropNameInRow="DESCRIPCION" msprop:Generator_ColumnPropNameInTable="DESCRIPCIONColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="PRO_MARCAS" msprop:Generator_UserTableName="PRO_MARCAS" msprop:Generator_RowDeletedName="PRO_MARCASRowDeleted" msprop:Generator_RowChangedName="PRO_MARCASRowChanged" msprop:Generator_RowClassName="PRO_MARCASRow" msprop:Generator_RowChangingName="PRO_MARCASRowChanging" msprop:Generator_RowEvArgName="PRO_MARCASRowChangeEvent" msprop:Generator_RowEvHandlerName="PRO_MARCASRowChangeEventHandler" msprop:Generator_TableClassName="PRO_MARCASDataTable" msprop:Generator_TableVarName="tablePRO_MARCAS" msprop:Generator_RowDeletingName="PRO_MARCASRowDeleting" msprop:Generator_TablePropName="PRO_MARCAS">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDMARCA" msprop:Generator_UserColumnName="IDMARCA" msprop:Generator_ColumnVarNameInTable="columnIDMARCA" msprop:Generator_ColumnPropNameInRow="IDMARCA" msprop:Generator_ColumnPropNameInTable="IDMARCAColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DESCRIPCION" msprop:Generator_UserColumnName="DESCRIPCION" msprop:Generator_ColumnVarNameInTable="columnDESCRIPCION" msprop:Generator_ColumnPropNameInRow="DESCRIPCION" msprop:Generator_ColumnPropNameInTable="DESCRIPCIONColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PREFIJO" msprop:Generator_UserColumnName="PREFIJO" msprop:Generator_ColumnVarNameInTable="columnPREFIJO" msprop:Generator_ColumnPropNameInRow="PREFIJO" msprop:Generator_ColumnPropNameInTable="PREFIJOColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DIJITOSCONSEC" msprop:Generator_UserColumnName="DIJITOSCONSEC" msprop:Generator_ColumnPropNameInRow="DIJITOSCONSEC" msprop:Generator_ColumnVarNameInTable="columnDIJITOSCONSEC" msprop:Generator_ColumnPropNameInTable="DIJITOSCONSECColumn" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:PRO_PLANES" />
      <xs:field xpath="mstns:IDPLAN" />
    </xs:unique>
    <xs:unique name="PRO_PRODUCTO_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:PRO_PRODUCTO" />
      <xs:field xpath="mstns:IDPRODUCTO" />
    </xs:unique>
    <xs:unique name="PRO_TIPOPRODUCTO_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:PRO_TIPOPRODUCTO" />
      <xs:field xpath="mstns:IDTIPOPRODUCTO" />
    </xs:unique>
    <xs:unique name="PRO_ENCALISTAPRECIOS_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:PRO_ENCALISTAPRECIOS" />
      <xs:field xpath="mstns:IDLISTA" />
    </xs:unique>
    <xs:unique name="PRO_DETALLELISTAPRECIOS_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:PRO_DETALLELISTAPRECIOS" />
      <xs:field xpath="mstns:IDLISTA" />
      <xs:field xpath="mstns:IDPRODUCTO" />
      <xs:field xpath="mstns:FECHACREACION" />
    </xs:unique>
    <xs:unique name="PRO_CLASE_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:PRO_CLASE" />
      <xs:field xpath="mstns:IDCLASE" />
    </xs:unique>
    <xs:unique name="PRO_MARCAS_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:PRO_MARCAS" />
      <xs:field xpath="mstns:IDMARCA" />
    </xs:unique>
    <xs:keyref name="FK_PRO_ENCALISTAPRECIOS_PRO_DETALLELISTAPRECIOS" refer="PRO_ENCALISTAPRECIOS_Constraint1" msprop:rel_Generator_UserRelationName="FK_PRO_ENCALISTAPRECIOS_PRO_DETALLELISTAPRECIOS" msprop:rel_Generator_RelationVarName="relationFK_PRO_ENCALISTAPRECIOS_PRO_DETALLELISTAPRECIOS" msprop:rel_Generator_UserChildTable="PRO_DETALLELISTAPRECIOS" msprop:rel_Generator_UserParentTable="PRO_ENCALISTAPRECIOS" msprop:rel_Generator_ParentPropName="PRO_ENCALISTAPRECIOSRow" msprop:rel_Generator_ChildPropName="GetPRO_DETALLELISTAPRECIOSRows">
      <xs:selector xpath=".//mstns:PRO_DETALLELISTAPRECIOS" />
      <xs:field xpath="mstns:IDLISTA" />
    </xs:keyref>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="PRO_DETALLELISTAPRECIOS_PRO_PRODUCTO" msdata:parent="PRO_DETALLELISTAPRECIOS" msdata:child="PRO_PRODUCTO" msdata:parentkey="IDPRODUCTO" msdata:childkey="IDPRODUCTO" msprop:Generator_UserRelationName="PRO_DETALLELISTAPRECIOS_PRO_PRODUCTO" msprop:Generator_RelationVarName="relationPRO_DETALLELISTAPRECIOS_PRO_PRODUCTO" msprop:Generator_UserChildTable="PRO_PRODUCTO" msprop:Generator_UserParentTable="PRO_DETALLELISTAPRECIOS" msprop:Generator_ParentPropName="PRO_DETALLELISTAPRECIOSRow" msprop:Generator_ChildPropName="GetPRO_PRODUCTORows" />
      <msdata:Relationship name="FK_DETALLELISTA_PRODUCTO" msdata:parent="PRO_PRODUCTO" msdata:child="PRO_DETALLELISTAPRECIOS" msdata:parentkey="IDPRODUCTO" msdata:childkey="IDPRODUCTO" msprop:Generator_UserRelationName="FK_DETALLELISTA_PRODUCTO" msprop:Generator_RelationVarName="relationFK_DETALLELISTA_PRODUCTO" msprop:Generator_UserChildTable="PRO_DETALLELISTAPRECIOS" msprop:Generator_UserParentTable="PRO_PRODUCTO" msprop:Generator_ParentPropName="PRO_PRODUCTORow" msprop:Generator_ChildPropName="GetPRO_DETALLELISTAPRECIOSRows" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>